Computer science Lesson Plan
Class: 6th to 8th - Lesson:2.3 Editing operations in spreadsheet

Purpose: Students should learn Cut, Copy, Paste, Delete Row/ Delete column, Resize column and row, Delete sheet in spreadsheet.

No. of Classes

Two or three classes (Teacher's decision).

Material Required

Open office(Spreadsheet).

Curriculum Content
  • 3.3.7) Editing operations
  • Cut
  • Copy
  • Paste
  • Delete Row/ Delete column
  • Resize column and row
  • Delete sheet

    • Prior knowledge

    Students should complete lesson plan-2.2 clearly.

    Exercises

    Exercise:1


    1. Students should copy an image and paste it in a new spreadsheet file and save the spreadsheet file.

    Exercise:2


    2. Delete sheet -2 in the spreadsheet and rename the sheet-3.

    Solution


  • Link to view the solutions for exercise-1 and exercise-2.

    • Teacher's Instruction
    1. Teachers should instruct the students to open a new spreadsheet and complete the above two exercises.
    2. Teachers should ensure that students learn how to save a spreadsheet file.
    3. Teachers should explain to the students about the differences between ‘cut’ and ‘copy’.